﻿CREATE TABLE [dbo].[ContactPerson_Log] (
    [Id]           INT              IDENTITY (1, 1) NOT NULL,
    [CustomerId]   UNIQUEIDENTIFIER NULL,
    [PersonId]     UNIQUEIDENTIFIER NULL,
    [ZName]        NVARCHAR (50)    NULL,
    [Sex]          NVARCHAR (10)    NULL,
    [Position]     NVARCHAR (50)    NULL,
    [OfficeTel]    NVARCHAR (50)    NULL,
    [HomeTel]      NVARCHAR (50)    NULL,
    [Mobile]       NVARCHAR (50)    NULL,
    [Email]        NVARCHAR (50)    NULL,
    [CreateDate]   DATETIME         NULL,
    [IsMain]       BIT              NULL,
    [PersonTypeId] INT              NULL,
    [Age]          INT              NULL,
    [Weixin]       NVARCHAR (50)    NULL
);

